While the number and types of data elements or fields that compose a table entry vary from table to table, they all contain two similar definition fields, the code and a longer description. The code is usually an all upper-case abbreviation that represents or corresponds to the longer table entry description. For example, in the table of states, the standard 2-character abbreviation (TX) is the code, and the state name (Texas) is the description.
The code is a critical field and is:
In most fields, iMIS only lets you enter or select a code that exists in a table entry definition. In a field referencing the STATE_PROVINCE table, for example, iMIS would reject the code "TT" as not being a valid table entry.
In assigning codes, follow these guidelines:
10.6 Production Release. Updated 1/18/2006 11:51:00 AM
© Copyright by Advanced Solutions International, Inc.
All rights reserved.